package com.example.bjsfpost.services;

import com.example.bjsfpost.domain.ErrorExcelData;
import com.example.bjsfpost.domain.PostParamDO;
import com.example.bjsfpost.sap.SapCommonResponseDO;
import com.github.pagehelper.PageInfo;

import java.util.List;

public interface PostParamService {

    //excel:
    //  execute:
    //      sql-path: C:\Users\liuzhuang-t\Desktop\idea-plugin\bjsf-post\SQL2Excel.xlsx
    SapCommonResponseDO executeSql2Excel();
    PageInfo handlerData(Integer pageNum,Integer pageSize);
    PageInfo handlerData1(Integer pageNum,Integer pageSize);
    PageInfo handlerData2(Integer pageNum,Integer pageSize);
    PageInfo handlerData3(Integer pageNum,Integer pageSize);
    PageInfo handlerData4(Integer pageNum,Integer pageSize);
    PageInfo handlerData5(Integer pageNum,Integer pageSize);
    PageInfo handlerData6(Integer pageNum,Integer pageSize);
    PageInfo handlerData7(Integer pageNum,Integer pageSize);
    PageInfo handlerData8(Integer pageNum,Integer pageSize);
    PageInfo handlerData9(Integer pageNum,Integer pageSize);
    PageInfo handlerData10(Integer pageNum,Integer pageSize);
    PageInfo handlerData11(Integer pageNum,Integer pageSize);
    PageInfo handlerData12(Integer pageNum,Integer pageSize);
    PageInfo handlerData13(Integer pageNum,Integer pageSize);
    PageInfo handlerData14(Integer pageNum,Integer pageSize);
    PageInfo handlerData15(Integer pageNum,Integer pageSize);
    PageInfo handlerData16(Integer pageNum,Integer pageSize);

    void handlerEtlWuliaoXls();

    /**
     * 扫描目录下所有excel文件
     */
    void handlerAllWuliaoExcelByFileName(String FileDirName,List<String> exclusionFileNames,String requestUrl);
    List<ErrorExcelData> handlerOneWuliaoExcelByFileName(String fileName, String url, String s);
    List<PostParamDO> queryAll4Bom(String FileName);
     void handlerBom4();
}
